//
//  DateBaseSingleton.h
//  UI-豆瓣项目APP
//
//  Created by dllo on 15/11/3.
//  Copyright © 2015年 孙鹏. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "Activitylist.h"
#import "UserList.h"
#import "ActivityDetailList.h"
#import "Movielist.h"
@interface DateBaseSingleton : NSObject

+(instancetype)shareDateBase;

-(void)openDB;

- (void)creatTable;

- (void)insertActivity:(Activitylist *)act;

-(NSMutableArray *)selectActivity;

-(void)dropTable;

-(void)creatUserTable;

- (void)insertUser:(UserList *)user;

-(NSMutableArray *)selectUserName;


-(void)dropUserTable;


-(NSMutableArray *)selectUser;

- (void)creatActivityDetailTable;


- (void)insertActivityDeatail:(Activitylist *)actDetail;


-(NSMutableArray *)selectActivityDetail;

- (void)deleteActivityDetail:(NSString *)name;

-(NSMutableArray *)selectActivityDetailName:(NSString *)userName;


- (void)creatMovieTable;

- (void)insertMovie:(Movielist *)movie;

-(NSMutableArray *)selectMovie;

-(void)dropMovieTable;


- (void)creatMovieDetailTable;

- (void)insertMovieDetail:(Movielist *)movie;

-(NSMutableArray *)selectMovieDetail;

-(void)dropMovieDetailTable;

-(NSMutableArray *)selectMovieUserName:(NSString *)userName;

- (void)creatMovieUserTable;

- (void)insertMovieUser:(Movielist *)movie;



@end
